/**
 * Marmoset: a student project snapshot, submission, testing and code review
 * system developed by the Univ. of Maryland, College Park
 * 
 * Developed as part of Jaime Spacco's Ph.D. thesis work, continuing effort led
 * by William Pugh. See http://marmoset.cs.umd.edu/
 * 
 * Copyright 2005 - 2011, Univ. of Maryland
 * 
 * Licensed under the Apache License, Version 2.0 (the "License"); you may not
 * use this file except in compliance with the License. You may obtain a copy of
 * the License at
 * 
 * http://www.apache.org/licenses/LICENSE-2.0
 * 
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
 * WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
 * License for the specific language governing permissions and limitations under
 * the License.
 * 
 */

/*
 * Created on Jun 24, 2005
 */
package edu.umd.cs.submitServer.servlets;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.SQLException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import edu.umd.cs.marmoset.modelClasses.Course;
import edu.umd.cs.marmoset.modelClasses.EclipseLaunchEvent;
import edu.umd.cs.marmoset.modelClasses.Project;
import edu.umd.cs.marmoset.modelClasses.StudentRegistration;
import edu.umd.cs.marmoset.modelClasses.StudentSubmitStatus;

/**
 * @author jspacco
 *
 */
public class Fixup extends SubmitServerServlet {

    @Override
    public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        Connection conn = null;
        response.setContentType("text/plain");
        PrintWriter out = response.getWriter();
        out.printf("%4s %6s %s%n", "num", "proj", "who");
        try {
            conn = getConnection();
            Course course = (Course) request.getAttribute(COURSE);

            for (StudentRegistration sr : StudentRegistration.lookupAllByCoursePK(course.getCoursePK(), conn))
                 for (Project project : Project.lookupAllByCoursePK(course.getCoursePK(), conn))
                {
                    int totalEclipseLaunchEvents = EclipseLaunchEvent
                            .countEclipseLaunchEventsByProjectPKAndStudentRegistration(project, sr, conn);
                    StudentSubmitStatus status = StudentSubmitStatus.lookupByStudentRegistrationPKAndProjectPK(
                            sr.getStudentRegistrationPK(), project.getProjectPK(), conn);
                    if (status == null)
                        continue;
                    status.setNumberRuns(totalEclipseLaunchEvents);
                    status.update(conn);
                    out.printf("%4d %6s %s%n", totalEclipseLaunchEvents, project.getProjectNumber(), sr.getFullname());

                }

        } catch (SQLException e) {
            handleSQLException(e);
            throw new ServletException(e);
        } finally {
            releaseConnection(conn);
            out.close();
        }
    }

}
